Release 10.1A: OpenEdge Data Management:
Database Administration

Create a database structure extent

Use the PROSTRCT CREATE utility to create the physical database files for the database. The PROSTRCT CREATE syntax is:

prostrct create db-name [structure-description-file]                         [-blocksize blocksize]                         [-validate]

In the syntax block, structure-description-file represents the name of the .st file. If you do not specify the name of the .st file, PROSTRCT uses db-name.st. The database blocksize in kilobytes is represented by blocksize. Specify 1024, 2048, 4096, or 8192. If you specify -validate, PROSTRCT will check that the contents of your structure description file are accurate without creating the database.

To create a database named sports2000 from the sports2000.st structure description file, use PROSTRCT CREATE as follows:

First verify that your structure description file is accurate, use the -validate option to PROSTRCT CREATE as follows:

prostrct create sports2000 sports2000.st -blocksize 4096 -validate

If there are no errors in your structure description file, PROSTRCT returns a status similar to the following:

The structure file format is valid. (12619) Device: /usr1/dbs/, KBytes needed: 3488, KBytes available: 483876225 (12616) There is sufficient free space to initialize the defined extents. (12618)

Second, create the as follows:

prostrct create sports2000 sports2000.st -blocksize 4096